1 -- phpMyAdmin SQL Dump
2 -- version 4.8.3
3 -- https://www.phpmyadmin.net/
4 --
5 -- Host: localhost
6 -- Generation Time: Jun 13, 2019 at 11:09 AM
7 -- Server version: 8.0.12
8 -- PHP Version: 7.2.13
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET AUTOCOMMIT = 0;
12 START TRANSACTION;
13 SET time_zone = "+00:00";
14
15
16 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19 /*!40101 SET NAMES utf8mb4 */;
20
21 --
22 -- Database: `academy_2.0.1`
23 --
24
25 -- --------------------------------------------------------
26
27 --
28 -- Table structure for table `category`
29 --
30
31 DROP TABLE IF EXISTS `category`;
32 CREATE TABLE `category` (
33 `id` int(11) UNSIGNED NOT NULL,
34 `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
35 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
36 `parent` int(11) DEFAULT '0',
37 `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
38 `date_added` int(11) DEFAULT NULL,
39 `last_modified` int(11) DEFAULT NULL,
40 `font_awesome_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
41 `thumbnail` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
43
44 -- --------------------------------------------------------
45
46 --
47 -- Table structure for table `ci_sessions`
48 --
49
50 DROP TABLE IF EXISTS `ci_sessions`;
51 CREATE TABLE `ci_sessions` (
52 `id` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
53 `ip_address` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
54 `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
55 `data` blob NOT NULL
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
57
58 -- --------------------------------------------------------
59
60 --
61 -- Table structure for table `comment`
62 --
63
64 DROP TABLE IF EXISTS `comment`;
65 CREATE TABLE `comment` (
66 `id` int(11) UNSIGNED NOT NULL,
67 `body` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
68 `user_id` int(11) DEFAULT NULL,
69 `commentable_id` int(11) DEFAULT NULL,
70 `commentable_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
71 `date_added` int(11) DEFAULT NULL,
72 `last_modified` int(11) DEFAULT NULL
73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
74
75 -- --------------------------------------------------------
76
77 --
78 -- Table structure for table `course`
79 --
80
81 DROP TABLE IF EXISTS `course`;
82 CREATE TABLE `course` (
83 `id` int(11) UNSIGNED NOT NULL,
84 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
85 `short_description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
86 `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
87 `outcomes` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
88 `language` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
89 `category_id` int(11) DEFAULT NULL,
90 `sub_category_id` int(11) DEFAULT NULL,
91 `section` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
92 `requirements` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
93 `price` double DEFAULT NULL,
94 `discount_flag` int(11) DEFAULT '0',
95 `discounted_price` int(11) DEFAULT NULL,
96 `level` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
97 `user_id` int(11) DEFAULT NULL,
98 `thumbnail` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
99 `video_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
100 `date_added` int(11) DEFAULT NULL,
101 `last_modified` int(11) DEFAULT NULL,
102 `visibility` int(11) DEFAULT NULL,
103 `is_top_course` int(11) DEFAULT '0',
104 `is_admin` int(11) DEFAULT NULL,
105 `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
106 `course_overview_provider` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
107 `meta_keywords` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
108 `meta_description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
109 `is_free_course` int(11) DEFAULT NULL
110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
111
112 -- --------------------------------------------------------
113
114 --
115 -- Table structure for table `currency`
116 --
117
118 DROP TABLE IF EXISTS `currency`;
119 CREATE TABLE `currency` (
120 `id` int(11) NOT NULL,
121 `name` varchar(255) DEFAULT NULL,
122 `code` varchar(255) DEFAULT NULL,
123 `symbol` varchar(255) DEFAULT NULL,
124 `paypal_supported` int(11) DEFAULT NULL,
125 `stripe_supported` int(11) DEFAULT NULL
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
127
128 --
129 -- Dumping data for table `currency`
130 --
131
132 INSERT INTO `currency` (`id`, `name`, `code`, `symbol`, `paypal_supported`, `stripe_supported`) VALUES
133 (1, 'Leke', 'ALL', 'Lek', 0, 1),
134 (2, 'Dollars', 'USD', '$', 1, 1),
135 (3, 'Afghanis', 'AFN', '؋', 0, 1),
136 (4, 'Pesos', 'ARS', '$', 0, 1),
137 (5, 'Guilders', 'AWG', 'ƒ', 0, 1),
138 (6, 'Dollars', 'AUD', '$', 1, 1),
139 (7, 'New Manats', 'AZN', 'ман', 0, 1),
140 (8, 'Dollars', 'BSD', '$', 0, 1),
141 (9, 'Dollars', 'BBD', '$', 0, 1),
142 (10, 'Rubles', 'BYR', 'p.', 0, 0),
143 (11, 'Euro', 'EUR', '€', 1, 1),
144 (12, 'Dollars', 'BZD', 'BZ$', 0, 1),
145 (13, 'Dollars', 'BMD', '$', 0, 1),
146 (14, 'Bolivianos', 'BOB', '$b', 0, 1),
147 (15, 'Convertible Marka', 'BAM', 'KM', 0, 1),
148 (16, 'Pula', 'BWP', 'P', 0, 1),
149 (17, 'Leva', 'BGN', 'лв', 0, 1),
150 (18, 'Reais', 'BRL', 'R$', 1, 1),
151 (19, 'Pounds', 'GBP', '£', 1, 1),
152 (20, 'Dollars', 'BND', '$', 0, 1),
153 (21, 'Riels', 'KHR', '៛', 0, 1),
154 (22, 'Dollars', 'CAD', '$', 1, 1),
155 (23, 'Dollars', 'KYD', '$', 0, 1),
156 (24, 'Pesos', 'CLP', '$', 0, 1),
157 (25, 'Yuan Renminbi', 'CNY', '¥', 0, 1),
158 (26, 'Pesos', 'COP', '$', 0, 1),
159 (27, 'Colón', 'CRC', '₡', 0, 1),
160 (28, 'Kuna', 'HRK', 'kn', 0, 1),
161 (29, 'Pesos', 'CUP', '₱', 0, 0),
162 (30, 'Koruny', 'CZK', 'Kč', 1, 1),
163 (31, 'Kroner', 'DKK', 'kr', 1, 1),
164 (32, 'Pesos', 'DOP ', 'RD$', 0, 1),
165 (33, 'Dollars', 'XCD', '$', 0, 1),
166 (34, 'Pounds', 'EGP', '£', 0, 1),
167 (35, 'Colones', 'SVC', '$', 0, 0),
168 (36, 'Pounds', 'FKP', '£', 0, 1),
169 (37, 'Dollars', 'FJD', '$', 0, 1),
170 (38, 'Cedis', 'GHC', '¢', 0, 0),
171 (39, 'Pounds', 'GIP', '£', 0, 1),
172 (40, 'Quetzales', 'GTQ', 'Q', 0, 1),
173 (41, 'Pounds', 'GGP', '£', 0, 0),
174 (42, 'Dollars', 'GYD', '$', 0, 1),
175 (43, 'Lempiras', 'HNL', 'L', 0, 1),
176 (44, 'Dollars', 'HKD', '$', 1, 1),
177 (45, 'Forint', 'HUF', 'Ft', 1, 1),
178 (46, 'Kronur', 'ISK', 'kr', 0, 1),
179 (47, 'Rupees', 'INR', 'Rp', 0, 1),
180 (48, 'Rupiahs', 'IDR', 'Rp', 0, 1),
181 (49, 'Rials', 'IRR', '﷼', 0, 0),
182 (50, 'Pounds', 'IMP', '£', 0, 0),
183 (51, 'New Shekels', 'ILS', '₪', 1, 1),
184 (52, 'Dollars', 'JMD', 'J$', 0, 1),
185 (53, 'Yen', 'JPY', '¥', 1, 1),
186 (54, 'Pounds', 'JEP', '£', 0, 0),
187 (55, 'Tenge', 'KZT', 'лв', 0, 1),
188 (56, 'Won', 'KPW', '₩', 0, 0),
189 (57, 'Won', 'KRW', '₩', 0, 1),
190 (58, 'Soms', 'KGS', 'лв', 0, 1),
191 (59, 'Kips', 'LAK', '₭', 0, 1),
192 (60, 'Lati', 'LVL', 'Ls', 0, 0),
193 (61, 'Pounds', 'LBP', '£', 0, 1),
194 (62, 'Dollars', 'LRD', '$', 0, 1),
195 (63, 'Switzerland Francs', 'CHF', 'CHF', 1, 1),
196 (64, 'Litai', 'LTL', 'Lt', 0, 0),
197 (65, 'Denars', 'MKD', 'ден', 0, 1),
198 (66, 'Ringgits', 'MYR', 'RM', 1, 1),
199 (67, 'Rupees', 'MUR', '₨', 0, 1),
200 (68, 'Pesos', 'MXN', '$', 1, 1),
201 (69, 'Tugriks', 'MNT', '₮', 0, 1),
202 (70, 'Meticais', 'MZN', 'MT', 0, 1),
203 (71, 'Dollars', 'NAD', '$', 0, 1),
204 (72, 'Rupees', 'NPR', '₨', 0, 1),
205 (73, 'Guilders', 'ANG', 'ƒ', 0, 1),
206 (74, 'Dollars', 'NZD', '$', 1, 1),
207 (75, 'Cordobas', 'NIO', 'C$', 0, 1),
208 (76, 'Nairas', 'NGN', '₦', 0, 1),
209 (77, 'Krone', 'NOK', 'kr', 1, 1),
210 (78, 'Rials', 'OMR', '﷼', 0, 0),
211 (79, 'Rupees', 'PKR', '₨', 0, 1),
212 (80, 'Balboa', 'PAB', 'B/.', 0, 1),
213 (81, 'Guarani', 'PYG', 'Gs', 0, 1),
214 (82, 'Nuevos Soles', 'PEN', 'S/.', 0, 1),
215 (83, 'Pesos', 'PHP', 'Php', 1, 1),
216 (84, 'Zlotych', 'PLN', 'zł', 1, 1),
217 (85, 'Rials', 'QAR', '﷼', 0, 1),
218 (86, 'New Lei', 'RON', 'lei', 0, 1),
219 (87, 'Rubles', 'RUB', 'руб', 0, 1),
220 (88, 'Pounds', 'SHP', '£', 0, 1),
221 (89, 'Riyals', 'SAR', '﷼', 0, 1),
222 (90, 'Dinars', 'RSD', 'Дин.', 0, 1),
223 (91, 'Rupees', 'SCR', '₨', 0, 1),
224 (92, 'Dollars', 'SGD', '$', 1, 1),
225 (93, 'Dollars', 'SBD', '$', 0, 1),
226 (94, 'Shillings', 'SOS', 'S', 0, 1),
227 (95, 'Rand', 'ZAR', 'R', 0, 1),
228 (96, 'Rupees', 'LKR', '₨', 0, 1),
229 (97, 'Kronor', 'SEK', 'kr', 1, 1),
230 (98, 'Dollars', 'SRD', '$', 0, 1),
231 (99, 'Pounds', 'SYP', '£', 0, 0),
232 (100, 'New Dollars', 'TWD', 'NT$', 1, 1),
233 (101, 'Baht', 'THB', '฿', 1, 1),
234 (102, 'Dollars', 'TTD', 'TT$', 0, 1),
235 (103, 'Lira', 'TRY', 'TL', 0, 1),
236 (104, 'Liras', 'TRL', '£', 0, 0),
237 (105, 'Dollars', 'TVD', '$', 0, 0),
238 (106, 'Hryvnia', 'UAH', '₴', 0, 1),
239 (107, 'Pesos', 'UYU', '$U', 0, 1),
240 (108, 'Sums', 'UZS', 'лв', 0, 1),
241 (109, 'Bolivares Fuertes', 'VEF', 'Bs', 0, 0),
242 (110, 'Dong', 'VND', '₫', 0, 1),
243 (111, 'Rials', 'YER', '﷼', 0, 1),
244 (112, 'Zimbabwe Dollars', 'ZWD', 'Z$', 0, 0);
245
246 -- --------------------------------------------------------
247
248 --
249 -- Table structure for table `enrol`
250 --
251
252 DROP TABLE IF EXISTS `enrol`;
253 CREATE TABLE `enrol` (
254 `id` int(11) UNSIGNED NOT NULL,
255 `user_id` int(11) DEFAULT NULL,
256 `course_id` int(11) DEFAULT NULL,
257 `date_added` int(11) DEFAULT NULL,
258 `last_modified` int(11) DEFAULT NULL
259 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
260
261 -- --------------------------------------------------------
262
263 --
264 -- Table structure for table `frontend_settings`
265 --
266
267 DROP TABLE IF EXISTS `frontend_settings`;
268 CREATE TABLE `frontend_settings` (
269 `id` int(11) UNSIGNED NOT NULL,
270 `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
271 `value` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
272 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
273
274 --
275 -- Dumping data for table `frontend_settings`
276 --
277
278 INSERT INTO `frontend_settings` (`id`, `key`, `value`) VALUES
279 (1, 'banner_title', 'Learn on your schedule'),
280 (2, 'banner_sub_title', 'Study any topic, anytime. Explore thousands of courses for the lowest price ever!'),
281 (4, 'about_us', '<p></p><h2>This is about us</h2><p><span xss=\"removed\" xss=removed>Welcome to Academy. It will help you to learn in a new ways</span></p>'),
282 (10, 'terms_and_condition', '<h2>Terms and Condition</h2>This is the Terms and condition page for your companys'),
283 (11, 'privacy_policy', '<h2>Privacy Policy</h2>This is the Privacy Policy page for your companys'),
284 (13, 'theme', 'default');
285
286 -- --------------------------------------------------------
287
288 --
289 -- Table structure for table `language`
290 --
291
292 DROP TABLE IF EXISTS `language`;
293 CREATE TABLE `language` (
294 `phrase_id` int(11) NOT NULL,
295 `phrase` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
296 `english` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
297 `Bengali` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
298 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
299
300 --
301 -- Dumping data for table `language`
302 --
303
304 INSERT INTO `language` (`phrase_id`, `phrase`, `english`, `Bengali`) VALUES
305 (1, 'manage_profile', NULL, NULL),
306 (140, 'category_code', NULL, NULL),
307 (3, 'dashboard', NULL, NULL),
308 (4, 'categories', NULL, NULL),
309 (5, 'courses', NULL, NULL),
310 (6, 'students', NULL, NULL),
311 (7, 'enroll_history', NULL, NULL),
312 (8, 'message', NULL, NULL),
313 (9, 'settings', NULL, NULL),
314 (10, 'system_settings', NULL, NULL),
315 (11, 'frontend_settings', NULL, NULL),
316 (12, 'payment_settings', NULL, NULL),
317 (13, 'manage_language', NULL, NULL),
318 (14, 'edit_profile', NULL, NULL),
319 (15, 'log_out', NULL, NULL),
320 (16, 'first_name', NULL, NULL),
321 (17, 'last_name', NULL, NULL),
322 (18, 'email', NULL, NULL),
323 (19, 'facebook_link', NULL, NULL),
324 (20, 'twitter_link', NULL, NULL),
325 (21, 'linkedin_link', NULL, NULL),
326 (22, 'a_short_title_about_yourself', NULL, NULL),
327 (23, 'biography', NULL, NULL),
328 (24, 'photo', NULL, NULL),
329 (25, 'select_image', NULL, NULL),
330 (26, 'change', NULL, NULL),
331 (27, 'remove', NULL, NULL),
332 (28, 'update_profile', NULL, NULL),
333 (29, 'change_password', NULL, NULL),
334 (30, 'current_password', NULL, NULL),
335 (31, 'new_password', NULL, NULL),
336 (32, 'confirm_new_password', NULL, NULL),
337 (33, 'delete', NULL, NULL),
338 (34, 'cancel', NULL, NULL),
339 (35, 'are_you_sure_to_update_this_information', NULL, NULL),
340 (36, 'yes', NULL, NULL),
341 (37, 'no', NULL, NULL),
342 (38, 'system settings', NULL, NULL),
343 (39, 'system_name', NULL, NULL),
344 (40, 'system_title', NULL, NULL),
345 (41, 'slogan', NULL, NULL),
346 (42, 'system_email', NULL, NULL),
347 (43, 'address', NULL, NULL),
348 (44, 'phone', NULL, NULL),
349 (45, 'youtube_api_key', NULL, NULL),
350 (46, 'get_youtube_api_key', NULL, NULL),
351 (47, 'vimeo_api_key', NULL, NULL),
352 (48, 'purchase_code', NULL, NULL),
353 (49, 'language', NULL, NULL),
354 (50, 'text-align', NULL, NULL),
355 (51, 'update_system_settings', NULL, NULL),
356 (52, 'update_product', NULL, NULL),
357 (53, 'file', NULL, NULL),
358 (54, 'install_update', NULL, NULL),
359 (55, 'system_logo', NULL, NULL),
360 (56, 'update_logo', NULL, NULL),
361 (57, 'get_vimeo_api_key', NULL, NULL),
362 (58, 'add_category', NULL, NULL),
363 (59, 'category_title', NULL, NULL),
364 (60, 'sub_categories', NULL, NULL),
365 (61, 'actions', NULL, NULL),
366 (62, 'action', NULL, NULL),
367 (63, 'manage_sub_categories', NULL, NULL),
368 (64, 'edit', NULL, NULL),
369 (65, 'add_course', NULL, NULL),
370 (66, 'select_category', NULL, NULL),
371 (67, 'title', NULL, NULL),
372 (68, 'category', NULL, NULL),
373 (69, '#_section', NULL, NULL),
374 (70, '#_lesson', NULL, NULL),
375 (71, '#_enrolled_user', NULL, NULL),
376 (72, 'view_course_details', NULL, NULL),
377 (73, 'manage_section', NULL, NULL),
378 (74, 'manage_lesson', NULL, NULL),
379 (75, 'student', NULL, NULL),
380 (76, 'add_student', NULL, NULL),
381 (77, 'name', NULL, NULL),
382 (78, 'date_added', NULL, NULL),
383 (79, 'enrolled_courses', NULL, NULL),
384 (80, 'view_profile', NULL, NULL),
385 (81, 'admin_dashboard', NULL, NULL),
386 (82, 'total_courses', NULL, NULL),
387 (83, 'number_of_courses', NULL, NULL),
388 (84, 'total_lessons', NULL, NULL),
389 (85, 'number_of_lessons', NULL, NULL),
390 (86, 'total_enrollment', NULL, NULL),
391 (87, 'number_of_enrollment', NULL, NULL),
392 (88, 'total_student', NULL, NULL),
393 (89, 'number_of_student', NULL, NULL),
394 (90, 'manage_sections', NULL, NULL),
395 (91, 'manage sections', NULL, NULL),
396 (92, 'course', NULL, NULL),
397 (93, 'add_section', NULL, NULL),
398 (94, 'lessons', NULL, NULL),
399 (95, 'serialize_sections', NULL, NULL),
400 (96, 'add_lesson', NULL, NULL),
401 (97, 'edit_section', NULL, NULL),
402 (98, 'delete_section', NULL, NULL),
403 (99, 'course_details', NULL, NULL),
404 (100, 'course details', NULL, NULL),
405 (101, 'details', NULL, NULL),
406 (102, 'instructor', NULL, NULL),
407 (103, 'sub_category', NULL, NULL),
408 (104, 'enrolled_user', NULL, NULL),
409 (105, 'last_modified', NULL, NULL),
410 (106, 'manage language', NULL, NULL),
411 (107, 'language_list', NULL, NULL),
412 (108, 'add_phrase', NULL, NULL),
413 (109, 'add_language', NULL, NULL),
414 (110, 'option', NULL, NULL),
415 (111, 'edit_phrase', NULL, NULL),
416 (112, 'delete_language', NULL, NULL),
417 (113, 'phrase', NULL, NULL),
418 (114, 'value_required', NULL, NULL),
419 (115, 'frontend settings', NULL, NULL),
420 (116, 'banner_title', NULL, NULL),
421 (117, 'banner_sub_title', NULL, NULL),
422 (118, 'about_us', NULL, NULL),
423 (119, 'blog', NULL, NULL),
424 (120, 'update_frontend_settings', NULL, NULL),
425 (121, 'update_banner', NULL, NULL),
426 (122, 'banner_image', NULL, NULL),
427 (123, 'update_banner_image', NULL, NULL),
428 (124, 'payment settings', NULL, NULL),
429 (125, 'paypal_settings', NULL, NULL),
430 (126, 'client_id', NULL, NULL),
431 (127, 'sandbox', NULL, NULL),
432 (128, 'production', NULL, NULL),
433 (129, 'active', NULL, NULL),
434 (130, 'mode', NULL, NULL),
435 (131, 'stripe_settings', NULL, NULL),
436 (132, 'testmode', NULL, NULL),
437 (133, 'on', NULL, NULL),
438 (134, 'off', NULL, NULL),
439 (135, 'test_secret_key', NULL, NULL),
440 (136, 'test_public_key', NULL, NULL),
441 (137, 'live_secret_key', NULL, NULL),
442 (138, 'live_public_key', NULL, NULL),
443 (139, 'save_changes', NULL, NULL),
444 (141, 'update_phrase', NULL, NULL),
445 (142, 'check', NULL, NULL),
446 (143, 'settings_updated', NULL, NULL),
447 (144, 'checking', NULL, NULL),
448 (145, 'phrase_added', NULL, NULL),
449 (146, 'language_added', NULL, NULL),
450 (147, 'language_deleted', NULL, NULL),
451 (148, 'add course', NULL, NULL),
452 (149, 'add_courses', NULL, NULL),
453 (150, 'add_course_form', NULL, NULL),
454 (151, 'basic_info', NULL, NULL),
455 (152, 'short_description', NULL, NULL),
456 (153, 'description', NULL, NULL),
457 (154, 'level', NULL, NULL),
458 (155, 'beginner', NULL, NULL),
459 (156, 'advanced', NULL, NULL),
460 (157, 'intermediate', NULL, NULL),
461 (158, 'language_made_in', NULL, NULL),
462 (159, 'is_top_course', NULL, NULL),
463 (160, 'outcomes', NULL, NULL),
464 (161, 'category_and_sub_category', NULL, NULL),
465 (162, 'select_a_category', NULL, NULL),
466 (163, 'select_a_category_first', NULL, NULL),
467 (164, 'requirements', NULL, NULL),
468 (165, 'price_and_discount', NULL, NULL),
469 (166, 'price', NULL, NULL),
470 (167, 'has_discount', NULL, NULL),
471 (168, 'discounted_price', NULL, NULL),
472 (169, 'course_thumbnail', NULL, NULL),
473 (170, 'note', NULL, NULL),
474 (171, 'thumbnail_size_should_be_600_x_600', NULL, NULL),
475 (172, 'course_overview_url', NULL, NULL),
476 (173, '0%', NULL, NULL),
477 (174, 'manage profile', NULL, NULL),
478 (175, 'edit_course', NULL, NULL),
479 (176, 'edit course', NULL, NULL),
480 (177, 'edit_courses', NULL, NULL),
481 (178, 'edit_course_form', NULL, NULL),
482 (179, 'update_course', NULL, NULL),
483 (180, 'course_updated', NULL, NULL),
484 (181, 'number_of_sections', NULL, NULL),
485 (182, 'number_of_enrolled_users', NULL, NULL),
486 (183, 'add section', NULL, NULL),
487 (184, 'section', NULL, NULL),
488 (185, 'add_section_form', NULL, NULL),
489 (186, 'update', NULL, NULL),
490 (187, 'serialize_section', NULL, NULL),
491 (188, 'serialize section', NULL, NULL),
492 (189, 'submit', NULL, NULL),
493 (190, 'sections_have_been_serialized', NULL, NULL),
494 (191, 'select_course', NULL, NULL),
495 (192, 'search', NULL, NULL),
496 (193, 'thumbnail', NULL, NULL),
497 (194, 'duration', NULL, NULL),
498 (195, 'provider', NULL, NULL),
499 (196, 'add lesson', NULL, NULL),
500 (197, 'add_lesson_form', NULL, NULL),
501 (198, 'video_type', NULL, NULL),
502 (199, 'select_a_course', NULL, NULL),
503 (200, 'select_a_course_first', NULL, NULL),
504 (201, 'video_url', NULL, NULL),
505 (202, 'invalid_url', NULL, NULL),
506 (203, 'your_video_source_has_to_be_either_youtube_or_vimeo', NULL, NULL),
507 (204, 'for', NULL, NULL),
508 (205, 'of', NULL, NULL),
509 (206, 'edit_lesson', NULL, NULL),
510 (207, 'edit lesson', NULL, NULL),
511 (208, 'edit_lesson_form', NULL, NULL),
512 (209, 'login', NULL, NULL),
513 (210, 'password', NULL, NULL),
514 (211, 'forgot_password', NULL, NULL),
515 (212, 'back_to_website', NULL, NULL),
516 (213, 'send_mail', NULL, NULL),
517 (214, 'back_to_login', NULL, NULL),
518 (215, 'student_add', NULL, NULL),
519 (216, 'student add', NULL, NULL),
520 (217, 'add_students', NULL, NULL),
521 (218, 'student_add_form', NULL, NULL),
522 (219, 'login_credentials', NULL, NULL),
523 (220, 'social_information', NULL, NULL),
524 (221, 'facebook', NULL, NULL),
525 (222, 'twitter', NULL, NULL),
526 (223, 'linkedin', NULL, NULL),
527 (224, 'user_image', NULL, NULL),
528 (225, 'add_user', NULL, NULL),
529 (226, 'user_update_successfully', NULL, NULL),
530 (227, 'user_added_successfully', NULL, NULL),
531 (228, 'student_edit', NULL, NULL),
532 (229, 'student edit', NULL, NULL),
533 (230, 'edit_students', NULL, NULL),
534 (231, 'student_edit_form', NULL, NULL),
535 (232, 'update_user', NULL, NULL),
536 (233, 'enroll history', NULL, NULL),
537 (234, 'filter', NULL, NULL),
538 (235, 'user_name', NULL, NULL),
539 (236, 'enrolled_course', NULL, NULL),
540 (237, 'enrollment_date', NULL, NULL),
541 (238, 'biography2', NULL, NULL),
542 (239, 'home', NULL, NULL),
543 (240, 'search_for_courses', NULL, NULL),
544 (241, 'total', NULL, NULL),
545 (242, 'go_to_cart', NULL, NULL),
546 (243, 'your_cart_is_empty', NULL, NULL),
547 (244, 'log_in', NULL, NULL),
548 (245, 'sign_up', NULL, NULL),
549 (246, 'what_do_you_want_to_learn', NULL, NULL),
550 (247, 'online_courses', NULL, NULL),
551 (248, 'explore_a_variety_of_fresh_topics', NULL, NULL),
552 (249, 'expert_instruction', NULL, NULL),
553 (250, 'find_the_right_course_for_you', NULL, NULL),
554 (251, 'lifetime_access', NULL, NULL),
555 (252, 'learn_on_your_schedule', NULL, NULL),
556 (253, 'top_courses', NULL, NULL),
557 (254, 'last_updater', NULL, NULL),
558 (255, 'hours', NULL, NULL),
559 (256, 'add_to_cart', NULL, NULL),
560 (257, 'top', NULL, NULL),
561 (258, 'latest_courses', NULL, NULL),
562 (259, 'added_to_cart', NULL, NULL),
563 (260, 'admin', NULL, NULL),
564 (261, 'log_in_to_your_udemy_account', NULL, NULL),
565 (262, 'by_signing_up_you_agree_to_our', NULL, NULL),
566 (263, 'terms_of_use', NULL, NULL),
567 (264, 'and', NULL, NULL),
568 (265, 'privacy_policy', NULL, NULL),
569 (266, 'do_not_have_an_account', NULL, NULL),
570 (267, 'sign_up_and_start_learning', NULL, NULL),
571 (268, 'check_here_for_exciting_deals_and_personalized_course_recommendations', NULL, NULL),
572 (269, 'already_have_an_account', NULL, NULL),
573 (270, 'checkout', NULL, NULL),
574 (271, 'paypal', NULL, NULL),
575 (272, 'stripe', NULL, NULL),
576 (273, 'step', NULL, NULL),
577 (274, 'how_would_you_rate_this_course_overall', NULL, NULL),
578 (275, 'write_a_public_review', NULL, NULL),
579 (276, 'describe_your_experience_what_you_got_out_of_the_course_and_other_helpful_highlights', NULL, NULL),
580 (277, 'what_did_the_instructor_do_well_and_what_could_use_some_improvement', NULL, NULL),
581 (278, 'next', NULL, NULL),
582 (279, 'previous', NULL, NULL),
583 (280, 'publish', NULL, NULL),
584 (281, 'search_results', NULL, NULL),
585 (282, 'ratings', NULL, NULL),
586 (283, 'search_results_for', NULL, NULL),
587 (284, 'category_page', NULL, NULL),
588 (285, 'all', NULL, NULL),
589 (286, 'category_list', NULL, NULL),
590 (287, 'by', NULL, NULL),
591 (288, 'go_to_wishlist', NULL, NULL),
592 (289, 'hi', NULL, NULL),
593 (290, 'my_courses', NULL, NULL),
594 (291, 'my_wishlist', NULL, NULL),
595 (292, 'my_messages', NULL, NULL),
596 (293, 'purchase_history', NULL, NULL),
597 (294, 'user_profile', NULL, NULL),
598 (295, 'already_purchased', NULL, NULL),
599 (296, 'all_courses', NULL, NULL),
600 (297, 'wishlists', NULL, NULL),
601 (298, 'search_my_courses', NULL, NULL),
602 (299, 'students_enrolled', NULL, NULL),
603 (300, 'created_by', NULL, NULL),
604 (301, 'last_updated', NULL, NULL),
605 (302, 'what_will_i_learn', NULL, NULL),
606 (303, 'view_more', NULL, NULL),
607 (304, 'other_related_courses', NULL, NULL),
608 (305, 'updated', NULL, NULL),
609 (306, 'curriculum_for_this_course', NULL, NULL),
610 (307, 'about_the_instructor', NULL, NULL),
611 (308, 'reviews', NULL, NULL),
612 (309, 'student_feedback', NULL, NULL),
613 (310, 'average_rating', NULL, NULL),
614 (311, 'preview_this_course', NULL, NULL),
615 (312, 'includes', NULL, NULL),
616 (313, 'on_demand_videos', NULL, NULL),
617 (314, 'full_lifetime_access', NULL, NULL),
618 (315, 'access_on_mobile_and_tv', NULL, NULL),
619 (316, 'course_preview', NULL, NULL),
620 (317, 'instructor_page', NULL, NULL),
621 (318, 'buy_now', NULL, NULL),
622 (319, 'shopping_cart', NULL, NULL),
623 (320, 'courses_in_cart', NULL, NULL),
624 (321, 'student_name', NULL, NULL),
625 (322, 'amount_to_pay', NULL, NULL),
626 (323, 'payment_successfully_done', NULL, NULL),
627 (324, 'filter_by', NULL, NULL),
628 (325, 'instructors', NULL, NULL),
629 (326, 'reset', NULL, NULL),
630 (327, 'your', NULL, NULL),
631 (328, 'rating', NULL, NULL),
632 (329, 'course_detail', NULL, NULL),
633 (330, 'start_lesson', NULL, NULL),
634 (331, 'show_full_biography', NULL, NULL),
635 (332, 'terms_and_condition', NULL, NULL),
636 (333, 'about', NULL, NULL),
637 (334, 'terms_&_condition', NULL, NULL),
638 (335, 'sub categories', NULL, NULL),
639 (336, 'add_sub_category', NULL, NULL),
640 (337, 'sub_category_title', NULL, NULL),
641 (338, 'add sub category', NULL, NULL),
642 (339, 'add_sub_category_form', NULL, NULL),
643 (340, 'sub_category_code', NULL, NULL),
644 (341, 'data_deleted', NULL, NULL),
645 (342, 'edit_category', NULL, NULL),
646 (343, 'edit category', NULL, NULL),
647 (344, 'edit_category_form', NULL, NULL),
648 (345, 'font', NULL, NULL),
649 (346, 'awesome class', NULL, NULL),
650 (347, 'update_category', NULL, NULL),
651 (348, 'data_updated_successfully', NULL, NULL),
652 (349, 'edit_sub_category', NULL, NULL),
653 (350, 'edit sub category', NULL, NULL),
654 (351, 'sub_category_edit', NULL, NULL),
655 (352, 'update_sub_category', NULL, NULL),
656 (353, 'course_added', NULL, NULL),
657 (354, 'user_deleted_successfully', NULL, NULL),
658 (355, 'private_messaging', NULL, NULL),
659 (356, 'private messaging', NULL, NULL),
660 (357, 'messages', NULL, NULL),
661 (358, 'select_message_to_read', NULL, NULL),
662 (359, 'new_message', NULL, NULL),
663 (360, 'email_duplication', NULL, NULL),
664 (361, 'your_registration_has_been_successfully_done', NULL, NULL),
665 (362, 'profile', NULL, NULL),
666 (363, 'account', NULL, NULL),
667 (364, 'add_information_about_yourself_to_share_on_your_profile', NULL, NULL),
668 (365, 'basics', NULL, NULL),
669 (366, 'add_your_twitter_link', NULL, NULL),
670 (367, 'add_your_facebook_link', NULL, NULL),
671 (368, 'add_your_linkedin_link', NULL, NULL),
672 (369, 'credentials', NULL, NULL),
673 (370, 'edit_your_account_settings', NULL, NULL),
674 (371, 'enter_current_password', NULL, NULL),
675 (372, 'enter_new_password', NULL, NULL),
676 (373, 're-type_your_password', NULL, NULL),
677 (374, 'save', NULL, NULL),
678 (375, 'update_user_photo', NULL, NULL),
679 (376, 'update_your_photo', NULL, NULL),
680 (377, 'upload_image', NULL, NULL),
681 (378, 'updated_successfully', NULL, NULL),
682 (379, 'invalid_login_credentials', NULL, NULL),
683 (380, 'blank_page', NULL, NULL),
684 (381, 'no_section_found', NULL, NULL),
685 (382, 'select_a_message_thread_to_read_it_here', NULL, NULL),
686 (383, 'send', NULL, NULL),
687 (384, 'type_your_message', NULL, NULL),
688 (385, 'date', NULL, NULL),
689 (386, 'total_price', NULL, NULL),
690 (387, 'payment_type', NULL, NULL),
691 (388, 'edit section', NULL, NULL),
692 (389, 'edit_section_form', NULL, NULL),
693 (390, 'reply_message', NULL, NULL),
694 (391, 'reply', NULL, NULL),
695 (392, 'log_in_to_your_account', NULL, NULL),
696 (393, 'no_result_found', NULL, NULL),
697 (394, 'enrollment', NULL, NULL),
698 (395, 'enroll_a_student', NULL, NULL),
699 (396, 'report', NULL, NULL),
700 (397, 'admin_revenue', NULL, NULL),
701 (398, 'instructor_revenue', NULL, NULL),
702 (399, 'instructor_settings', NULL, NULL),
703 (400, 'view_frontend', NULL, NULL),
704 (401, 'number_of_active_courses', NULL, NULL),
705 (402, 'number_of_pending_courses', NULL, NULL),
706 (403, 'all_instructor', NULL, NULL),
707 (404, 'active_courses', NULL, NULL),
708 (405, 'pending_courses', NULL, NULL),
709 (406, 'no_data_found', NULL, NULL),
710 (407, 'view_course_on_frontend', NULL, NULL),
711 (408, 'mark_as_pending', NULL, NULL),
712 (409, 'add category', NULL, NULL),
713 (410, 'add_categories', NULL, NULL),
714 (411, 'category_add_form', NULL, NULL),
715 (412, 'icon_picker', NULL, NULL),
716 (413, 'enroll a student', NULL, NULL),
717 (414, 'enrollment_form', NULL, NULL),
718 (415, 'admin revenue', NULL, NULL),
719 (416, 'total_amount', NULL, NULL),
720 (417, 'instructor revenue', NULL, NULL),
721 (418, 'status', NULL, NULL),
722 (419, 'instructor settings', NULL, NULL),
723 (420, 'allow_public_instructor', NULL, NULL),
724 (421, 'instructor_revenue_percentage', NULL, NULL),
725 (422, 'admin_revenue_percentage', NULL, NULL),
726 (423, 'update_instructor_settings', NULL, NULL),
727 (424, 'payment_info', NULL, NULL),
728 (425, 'required_for_instructors', NULL, NULL),
729 (426, 'paypal_client_id', NULL, NULL),
730 (427, 'stripe_public_key', NULL, NULL),
731 (428, 'stripe_secret_key', NULL, NULL),
732 (429, 'mark_as_active', NULL, NULL),
733 (430, 'mail_subject', NULL, NULL),
734 (431, 'mail_body', NULL, NULL),
735 (432, 'paid', NULL, NULL),
736 (433, 'pending', NULL, NULL),
737 (434, 'this_instructor_has_not_provided_valid_paypal_client_id', NULL, NULL),
738 (435, 'pay_with_paypal', NULL, NULL),
739 (436, 'this_instructor_has_not_provided_valid_public_key_or_secret_key', NULL, NULL),
740 (437, 'pay_with_stripe', NULL, NULL),
741 (438, 'create_course', NULL, NULL),
742 (439, 'payment_report', NULL, NULL),
743 (440, 'instructor_dashboard', NULL, NULL),
744 (441, 'draft', NULL, NULL),
745 (442, 'view_lessons', NULL, NULL),
746 (443, 'course_title', NULL, NULL),
747 (444, 'update_your_payment_settings', NULL, NULL),
748 (445, 'edit_course_detail', NULL, NULL),
749 (446, 'edit_basic_informations', NULL, NULL),
750 (447, 'publish_this_course', NULL, NULL),
751 (448, 'save_to_draft', NULL, NULL),
752 (449, 'update_section', NULL, NULL),
753 (450, 'analyzing_given_url', NULL, NULL),
754 (451, 'select_a_section', NULL, NULL),
755 (452, 'update_lesson', NULL, NULL),
756 (453, 'website_name', NULL, NULL),
757 (454, 'website_title', NULL, NULL),
758 (455, 'website_keywords', NULL, NULL),
759 (456, 'website_description', NULL, NULL),
760 (457, 'author', NULL, NULL),
761 (458, 'footer_text', NULL, NULL),
762 (459, 'footer_link', NULL, NULL),
763 (460, 'update_backend_logo', NULL, NULL),
764 (461, 'update_favicon', NULL, NULL),
765 (462, 'favicon', NULL, NULL),
766 (463, 'active courses', NULL, NULL),
767 (464, 'product_updated_successfully', NULL, NULL),
768 (465, 'course_overview_provider', NULL, NULL),
769 (466, 'youtube', NULL, NULL),
770 (467, 'vimeo', NULL, NULL),
771 (468, 'html5', NULL, NULL),
772 (469, 'meta_keywords', NULL, NULL),
773 (470, 'meta_description', NULL, NULL),
774 (471, 'lesson_type', NULL, NULL),
775 (472, 'video', NULL, NULL),
776 (473, 'select_type_of_lesson', NULL, NULL),
777 (474, 'text_file', NULL, NULL),
778 (475, 'pdf_file', NULL, NULL),
779 (476, 'document_file', NULL, NULL),
780 (477, 'image_file', NULL, NULL),
781 (478, 'lesson_provider', NULL, NULL),
782 (479, 'select_lesson_provider', NULL, NULL),
783 (480, 'analyzing_the_url', NULL, NULL),
784 (481, 'attachment', NULL, NULL),
785 (482, 'summary', NULL, NULL),
786 (483, 'download', NULL, NULL),
787 (484, 'system_settings_updated', NULL, NULL),
788 (485, 'course_updated_successfully', NULL, NULL),
789 (486, 'please_wait_untill_admin_approves_it', NULL, NULL),
790 (487, 'pending courses', NULL, NULL),
791 (488, 'course_status_updated', NULL, NULL),
792 (489, 'smtp_settings', NULL, NULL),
793 (490, 'free_course', NULL, NULL),
794 (491, 'free', NULL, NULL),
795 (492, 'get_enrolled', NULL, NULL),
796 (493, 'course_added_successfully', NULL, NULL),
797 (494, 'update_frontend_logo', NULL, NULL),
798 (495, 'system_currency_settings', NULL, NULL),
799 (496, 'select_system_currency', NULL, NULL),
800 (497, 'currency_position', NULL, NULL),
801 (498, 'left', NULL, NULL),
802 (499, 'right', NULL, NULL),
803 (500, 'left_with_a_space', NULL, NULL),
804 (501, 'right_with_a_space', NULL, NULL),
805 (502, 'paypal_currency', NULL, NULL),
806 (503, 'select_paypal_currency', NULL, NULL),
807 (504, 'stripe_currency', NULL, NULL),
808 (505, 'select_stripe_currency', NULL, NULL),
809 (506, 'heads_up', NULL, NULL),
810 (507, 'please_make_sure_that', NULL, NULL),
811 (508, 'system_currency', NULL, NULL),
812 (509, 'are_same', NULL, NULL),
813 (510, 'smtp settings', NULL, NULL),
814 (511, 'protocol', NULL, NULL),
815 (512, 'smtp_host', NULL, NULL),
816 (513, 'smtp_port', NULL, NULL),
817 (514, 'smtp_user', NULL, NULL),
818 (515, 'smtp_pass', NULL, NULL),
819 (516, 'update_smtp_settings', NULL, NULL),
820 (517, 'phrase_updated', NULL, NULL),
821 (518, 'registered_user', NULL, NULL),
822 (519, 'provide_your_valid_login_credentials', NULL, NULL),
823 (520, 'registration_form', NULL, NULL),
824 (521, 'provide_your_email_address_to_get_password', NULL, NULL),
825 (522, 'reset_password', NULL, NULL),
826 (523, 'want_to_go_back', NULL, NULL),
827 (524, 'message_sent!', NULL, NULL),
828 (525, 'selected_icon', NULL, NULL),
829 (526, 'pick_another_icon_picker', NULL, NULL),
830 (527, 'show_more', NULL, NULL),
831 (528, 'show_less', NULL, NULL),
832 (529, 'all_category', NULL, NULL),
833 (530, 'price_range', NULL, NULL),
834 (531, 'price_range_withing', NULL, NULL),
835 (532, 'all_categories', NULL, NULL),
836 (533, 'all_sub_category', NULL, NULL),
837 (534, 'number_of_results', NULL, NULL),
838 (535, 'showing_on_this_page', NULL, NULL),
839 (536, 'welcome', NULL, NULL),
840 (537, 'my_account', NULL, NULL),
841 (538, 'logout', NULL, NULL),
842 (539, 'visit_website', NULL, NULL),
843 (540, 'navigation', NULL, NULL),
844 (541, 'add_new_category', NULL, NULL),
845 (542, 'enrolment', NULL, NULL),
846 (543, 'enrol_history', NULL, NULL),
847 (544, 'enrol_a_student', NULL, NULL),
848 (545, 'language_settings', NULL, NULL),
849 (546, 'congratulations', NULL, NULL),
850 (547, 'oh_snap', NULL, NULL),
851 (548, 'close', NULL, NULL),
852 (549, 'parent', NULL, NULL),
853 (550, 'none', NULL, NULL),
854 (551, 'category_thumbnail', NULL, NULL),
855 (552, 'the_image_size_should_be', NULL, NULL),
856 (553, 'choose_thumbnail', NULL, NULL),
857 (554, 'data_added_successfully', NULL, NULL),
858 (555, '', NULL, NULL),
859 (556, 'update_category_form', NULL, NULL),
860 (557, 'student_list', NULL, NULL),
861 (558, 'choose_user_image', NULL, NULL),
862 (559, 'finish', NULL, NULL),
863 (560, 'thank_you', NULL, NULL),
864 (561, 'you_are_almost_there', NULL, NULL),
865 (562, 'you_are_just_one_click_away', NULL, NULL),
866 (563, 'country', NULL, NULL),
867 (564, 'website_settings', NULL, NULL),
868 (565, 'write_down_facebook_url', NULL, NULL),
869 (566, 'write_down_twitter_url', NULL, NULL),
870 (567, 'write_down_linkedin_url', NULL, NULL),
871 (568, 'google_link', NULL, NULL),
872 (569, 'write_down_google_url', NULL, NULL),
873 (570, 'instagram_link', NULL, NULL),
874 (571, 'write_down_instagram_url', NULL, NULL),
875 (572, 'pinterest_link', NULL, NULL),
876 (573, 'write_down_pinterest_url', NULL, NULL),
877 (574, 'update_settings', NULL, NULL),
878 (575, 'upload_banner_image', NULL, NULL),
879 (576, 'update_light_logo', NULL, NULL),
880 (577, 'upload_light_logo', NULL, NULL),
881 (578, 'update_dark_logo', NULL, NULL),
882 (579, 'upload_dark_logo', NULL, NULL),
883 (580, 'update_small_logo', NULL, NULL),
884 (581, 'upload_small_logo', NULL, NULL),
885 (582, 'upload_favicon', NULL, NULL),
886 (583, 'logo_updated', NULL, NULL),
887 (584, 'favicon_updated', NULL, NULL),
888 (585, 'banner_image_update', NULL, NULL),
889 (586, 'frontend_settings_updated', NULL, NULL),
890 (587, 'setup_payment_informations', NULL, NULL),
891 (588, 'update_system_currency', NULL, NULL),
892 (589, 'setup_paypal_settings', NULL, NULL),
893 (590, 'update_paypal_keys', NULL, NULL),
894 (591, 'setup_stripe_settings', NULL, NULL),
895 (592, 'test_mode', NULL, NULL),
896 (593, 'update_stripe_keys', NULL, NULL);
897
898 -- --------------------------------------------------------
899
900 --
901 -- Table structure for table `lesson`
902 --
903
904 DROP TABLE IF EXISTS `lesson`;
905 CREATE TABLE `lesson` (
906 `id` int(11) UNSIGNED NOT NULL,
907 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
908 `duration` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
909 `course_id` int(11) DEFAULT NULL,
910 `section_id` int(11) DEFAULT NULL,
911 `video_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
912 `video_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
913 `date_added` int(11) DEFAULT NULL,
914 `last_modified` int(11) DEFAULT NULL,
915 `lesson_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
916 `attachment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
917 `attachment_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
918 `summary` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
919 `order` int(11) NOT NULL DEFAULT '0'
920 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
921
922 -- --------------------------------------------------------
923
924 --
925 -- Table structure for table `message`
926 --
927
928 DROP TABLE IF EXISTS `message`;
929 CREATE TABLE `message` (
930 `message_id` int(11) NOT NULL,
931 `message_thread_code` longtext,
932 `message` longtext,
933 `sender` longtext,
934 `timestamp` longtext,
935 `read_status` int(11) DEFAULT NULL
936 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
937
938 -- --------------------------------------------------------
939
940 --
941 -- Table structure for table `message_thread`
942 --
943
944 DROP TABLE IF EXISTS `message_thread`;
945 CREATE TABLE `message_thread` (
946 `message_thread_id` int(11) NOT NULL,
947 `message_thread_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
948 `sender` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '',
949 `receiver` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '',
950 `last_message_timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
951 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
952
953 -- --------------------------------------------------------
954
955 --
956 -- Table structure for table `payment`
957 --
958
959 DROP TABLE IF EXISTS `payment`;
960 CREATE TABLE `payment` (
961 `id` int(11) UNSIGNED NOT NULL,
962 `user_id` int(11) DEFAULT NULL,
963 `payment_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
964 `course_id` int(11) DEFAULT NULL,
965 `amount` double DEFAULT NULL,
966 `date_added` int(11) DEFAULT NULL,
967 `last_modified` int(11) DEFAULT NULL,
968 `admin_revenue` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
969 `instructor_revenue` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
970 `instructor_payment_status` int(11) DEFAULT '0'
971 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
972
973 -- --------------------------------------------------------
974
975 --
976 -- Table structure for table `question`
977 --
978
979 DROP TABLE IF EXISTS `question`;
980 CREATE TABLE `question` (
981 `id` int(11) UNSIGNED NOT NULL,
982 `quiz_id` int(11) DEFAULT NULL,
983 `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
984 `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
985 `number_of_options` int(11) DEFAULT NULL,
986 `options` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
987 `correct_answers` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
988 `order` int(11) NOT NULL DEFAULT '0'
989 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
990
991 -- --------------------------------------------------------
992
993 --
994 -- Table structure for table `rating`
995 --
996
997 DROP TABLE IF EXISTS `rating`;
998 CREATE TABLE `rating` (
999 `id` int(11) UNSIGNED NOT NULL,
1000 `rating` double DEFAULT NULL,
1001 `user_id` int(11) DEFAULT NULL,
1002 `ratable_id` int(11) DEFAULT NULL,
1003 `ratable_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1004 `date_added` int(11) DEFAULT NULL,
1005 `last_modified` int(11) DEFAULT NULL,
1006 `review` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
1007 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1008
1009 -- --------------------------------------------------------
1010
1011 --
1012 -- Table structure for table `role`
1013 --
1014
1015 DROP TABLE IF EXISTS `role`;
1016 CREATE TABLE `role` (
1017 `id` int(11) UNSIGNED NOT NULL,
1018 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1019 `date_added` int(11) DEFAULT NULL,
1020 `last_modified` int(11) DEFAULT NULL
1021 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1022
1023 --
1024 -- Dumping data for table `role`
1025 --
1026
1027 INSERT INTO `role` (`id`, `name`, `date_added`, `last_modified`) VALUES
1028 (1, 'Admin', 1234567890, 1234567890),
1029 (2, 'User', 1234567890, 1234567890);
1030
1031 -- --------------------------------------------------------
1032
1033 --
1034 -- Table structure for table `section`
1035 --
1036
1037 DROP TABLE IF EXISTS `section`;
1038 CREATE TABLE `section` (
1039 `id` int(11) NOT NULL,
1040 `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1041 `course_id` int(11) DEFAULT NULL,
1042 `order` int(11) NOT NULL DEFAULT '0'
1043 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1044
1045 -- --------------------------------------------------------
1046
1047 --
1048 -- Table structure for table `settings`
1049 --
1050
1051 DROP TABLE IF EXISTS `settings`;
1052 CREATE TABLE `settings` (
1053 `id` int(11) UNSIGNED NOT NULL,
1054 `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1055 `value` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
1056 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1057
1058 --
1059 -- Dumping data for table `settings`
1060 --
1061
1062 INSERT INTO `settings` (`id`, `key`, `value`) VALUES
1063 (1, 'language', 'english'),
1064 (2, 'system_name', 'Academy Learning Club'),
1065 (3, 'system_title', 'Academy Learning Club'),
1066 (4, 'system_email', 'academy@example.com'),
1067 (5, 'address', 'Sydeny, Australia'),
1068 (6, 'phone', '+143-52-9933631'),
1069 (7, 'purchase_code', 'your-purchase-code'),
1070 (8, 'paypal', '[{\"active\":\"1\",\"mode\":\"sandbox\",\"sandbox_client_id\":\"AZDxjDScFpQtjWTOUtWKbyN_bDt4OgqaF4eYXlewfBP4-8aqX3PiV8e1GWU6liB2CUXlkA59kJXE7M6R\",\"production_client_id\":\"1234\"}]'),
1071 (9, 'stripe_keys', '[{\"active\":\"1\",\"testmode\":\"on\",\"public_key\":\"pk_test_c6VvBEbwHFdulFZ62q1IQrar\",\"secret_key\":\"sk_test_9IMkiM6Ykxr1LCe2dJ3PgaxS\",\"public_live_key\":\"pk_live_xxxxxxxxxxxxxxxxxxxxxxxx\",\"secret_live_key\":\"sk_live_xxxxxxxxxxxxxxxxxxxxxxxx\"}]'),
1072 (10, 'youtube_api_key', 'AIzaSyBBJrcS7AhGd1Cgd6GKH3G5aUUj9L9NrFQ'),
1073 (11, 'vimeo_api_key', '39258384b69994dba483c10286825b5c'),
1074 (12, 'slogan', 'A course based video CMS'),
1075 (13, 'text_align', NULL),
1076 (14, 'allow_instructor', '1'),
1077 (15, 'instructor_revenue', '64'),
1078 (16, 'system_currency', 'USD'),
1079 (17, 'paypal_currency', 'USD'),
1080 (18, 'stripe_currency', 'USD'),
1081 (19, 'author', 'Creativeitem'),
1082 (20, 'currency_position', 'left'),
1083 (21, 'website_description', 'Nice application'),
1084 (22, 'website_keywords', 'LMS,Learning Management System,Creativeitem,demo,hello,How are you'),
1085 (23, 'footer_text', NULL),
1086 (24, 'footer_link', 'http://creativeitem.com/'),
1087 (25, 'protocol', 'smtp'),
1088 (26, 'smtp_host', 'ssl://smtp.googlemail.com'),
1089 (27, 'smtp_port', '465'),
1090 (28, 'smtp_user', ''),
1091 (29, 'smtp_pass', ''),
1092 (30, 'version', '2.0.1'),
1093 (31, 'student_email_verification', 'disable');
1094
1095 -- --------------------------------------------------------
1096
1097 --
1098 -- Table structure for table `tag`
1099 --
1100
1101 DROP TABLE IF EXISTS `tag`;
1102 CREATE TABLE `tag` (
1103 `id` int(11) UNSIGNED NOT NULL,
1104 `tag` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1105 `tagable_id` int(11) DEFAULT NULL,
1106 `tagable_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1107 `date_added` int(11) DEFAULT NULL,
1108 `last_modified` int(11) DEFAULT NULL
1109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1110
1111 -- --------------------------------------------------------
1112
1113 --
1114 -- Table structure for table `users`
1115 --
1116
1117 DROP TABLE IF EXISTS `users`;
1118 CREATE TABLE `users` (
1119 `id` int(11) UNSIGNED NOT NULL,
1120 `first_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1121 `last_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1122 `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1123 `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1124 `social_links` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1125 `biography` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1126 `role_id` int(11) DEFAULT NULL,
1127 `date_added` int(11) DEFAULT NULL,
1128 `last_modified` int(11) DEFAULT NULL,
1129 `watch_history` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1130 `wishlist` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1131 `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1132 `paypal_keys` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1133 `stripe_keys` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1134 `verification_code` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1135 `status` int(11) DEFAULT NULL
1136 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1137
1138 --
1139 -- Indexes for dumped tables
1140 --
1141
1142 --
1143 -- Indexes for table `category`
1144 --
1145 ALTER TABLE `category`
1146 ADD PRIMARY KEY (`id`);
1147
1148 --
1149 -- Indexes for table `comment`
1150 --
1151 ALTER TABLE `comment`
1152 ADD PRIMARY KEY (`id`);
1153
1154 --
1155 -- Indexes for table `course`
1156 --
1157 ALTER TABLE `course`
1158 ADD PRIMARY KEY (`id`);
1159
1160 --
1161 -- Indexes for table `currency`
1162 --
1163 ALTER TABLE `currency`
1164 ADD PRIMARY KEY (`id`);
1165
1166 --
1167 -- Indexes for table `enrol`
1168 --
1169 ALTER TABLE `enrol`
1170 ADD PRIMARY KEY (`id`);
1171
1172 --
1173 -- Indexes for table `frontend_settings`
1174 --
1175 ALTER TABLE `frontend_settings`
1176 ADD PRIMARY KEY (`id`);
1177
1178 --
1179 -- Indexes for table `language`
1180 --
1181 ALTER TABLE `language`
1182 ADD PRIMARY KEY (`phrase_id`);
1183
1184 --
1185 -- Indexes for table `lesson`
1186 --
1187 ALTER TABLE `lesson`
1188 ADD PRIMARY KEY (`id`);
1189
1190 --
1191 -- Indexes for table `message`
1192 --
1193 ALTER TABLE `message`
1194 ADD PRIMARY KEY (`message_id`);
1195
1196 --
1197 -- Indexes for table `message_thread`
1198 --
1199 ALTER TABLE `message_thread`
1200 ADD PRIMARY KEY (`message_thread_id`);
1201
1202 --
1203 -- Indexes for table `payment`
1204 --
1205 ALTER TABLE `payment`
1206 ADD PRIMARY KEY (`id`);
1207
1208 --
1209 -- Indexes for table `question`
1210 --
1211 ALTER TABLE `question`
1212 ADD PRIMARY KEY (`id`);
1213
1214 --
1215 -- Indexes for table `rating`
1216 --
1217 ALTER TABLE `rating`
1218 ADD PRIMARY KEY (`id`);
1219
1220 --
1221 -- Indexes for table `role`
1222 --
1223 ALTER TABLE `role`
1224 ADD PRIMARY KEY (`id`);
1225
1226 --
1227 -- Indexes for table `section`
1228 --
1229 ALTER TABLE `section`
1230 ADD PRIMARY KEY (`id`);
1231
1232 --
1233 -- Indexes for table `settings`
1234 --
1235 ALTER TABLE `settings`
1236 ADD PRIMARY KEY (`id`);
1237
1238 --
1239 -- Indexes for table `tag`
1240 --
1241 ALTER TABLE `tag`
1242 ADD PRIMARY KEY (`id`);
1243
1244 --
1245 -- Indexes for table `users`
1246 --
1247 ALTER TABLE `users`
1248 ADD PRIMARY KEY (`id`);
1249
1250 --
1251 -- AUTO_INCREMENT for dumped tables
1252 --
1253
1254 --
1255 -- AUTO_INCREMENT for table `category`
1256 --
1257 ALTER TABLE `category`
1258 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1259
1260 --
1261 -- AUTO_INCREMENT for table `comment`
1262 --
1263 ALTER TABLE `comment`
1264 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1265
1266 --
1267 -- AUTO_INCREMENT for table `course`
1268 --
1269 ALTER TABLE `course`
1270 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1271
1272 --
1273 -- AUTO_INCREMENT for table `currency`
1274 --
1275 ALTER TABLE `currency`
1276 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;
1277
1278 --
1279 -- AUTO_INCREMENT for table `enrol`
1280 --
1281 ALTER TABLE `enrol`
1282 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1283
1284 --
1285 -- AUTO_INCREMENT for table `frontend_settings`
1286 --
1287 ALTER TABLE `frontend_settings`
1288 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
1289
1290 --
1291 -- AUTO_INCREMENT for table `language`
1292 --
1293 ALTER TABLE `language`
1294 MODIFY `phrase_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=594;
1295
1296 --
1297 -- AUTO_INCREMENT for table `lesson`
1298 --
1299 ALTER TABLE `lesson`
1300 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1301
1302 --
1303 -- AUTO_INCREMENT for table `message`
1304 --
1305 ALTER TABLE `message`
1306 MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT;
1307
1308 --
1309 -- AUTO_INCREMENT for table `message_thread`
1310 --
1311 ALTER TABLE `message_thread`
1312 MODIFY `message_thread_id` int(11) NOT NULL AUTO_INCREMENT;
1313
1314 --
1315 -- AUTO_INCREMENT for table `payment`
1316 --
1317 ALTER TABLE `payment`
1318 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1319
1320 --
1321 -- AUTO_INCREMENT for table `question`
1322 --
1323 ALTER TABLE `question`
1324 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1325
1326 --
1327 -- AUTO_INCREMENT for table `rating`
1328 --
1329 ALTER TABLE `rating`
1330 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1331
1332 --
1333 -- AUTO_INCREMENT for table `role`
1334 --
1335 ALTER TABLE `role`
1336 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1337
1338 --
1339 -- AUTO_INCREMENT for table `section`
1340 --
1341 ALTER TABLE `section`
1342 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1343
1344 --
1345 -- AUTO_INCREMENT for table `settings`
1346 --
1347 ALTER TABLE `settings`
1348 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
1349
1350 --
1351 -- AUTO_INCREMENT for table `tag`
1352 --
1353 ALTER TABLE `tag`
1354 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1355
1356 --
1357 -- AUTO_INCREMENT for table `users`
1358 --
1359 ALTER TABLE `users`
1360 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1361 COMMIT;
1362
1363 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1364 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1365 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
